| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
ProgramVersionId |
|
INTEGER |
NO |
|
ProgramId |
|
INTEGER |
YES |
|
DegreeId |
|
INTEGER |
NO |
|
ProgramGroupId |
|
INTEGER |
YES |
|
| Code |
|
CHAR(10) |
NO |
|
| Name |
|
VARCHAR(120) |
NO |
|
| CampusGroupId |
|
INTEGER |
NO |
|
| CreditHoursRequired |
|
NUMERIC(7, 2) |
NO |
|
| ClockHoursRequired |
|
NUMERIC(7, 2) |
NO |
|
| GradeScaleId |
|
INTEGER |
NO |
|
| IsGpaCalcWeighted |
|
BIT |
NO |
|
| BillingMethodId |
|
INTEGER |
YES |
|
| RevenueEarningMethodId |
|
INTEGER |
YES |
|
| RefundBasedOn |
|
CHAR(1) |
NO |
|
| SapTableId |
|
INTEGER |
NO |
|
| AdHonorsTableID |
|
INTEGER |
YES |
|
| TotalWeeks |
|
NUMERIC(7, 2) |
NO |
|
| TotalMonths |
|
NUMERIC(7, 2) |
NO |
|
| MonthsInTerm |
|
INTEGER |
NO |
|
| WeeksInTerm |
|
INTEGER |
NO |
|
| TotalLessons |
|
NUMERIC(3, 0) |
NO |
|
| AcademicCalendar |
|
CHAR(1) |
YES |
|
| ActiveWhen |
|
CHAR(1) |
YES |
|
| ActiveUnits |
|
SMALLINT |
YES |
|
| DaysBetweenLessons |
|
SMALLINT |
YES |
|
| NumberExtensions |
|
SMALLINT |
YES |
|
| CampusLicenseUnit |
|
CHAR(1) |
NO |
|
| CreditsInFullAcademicYear |
|
NUMERIC(7, 2) |
NO |
|
| WeeksInFullAcademicYear |
|
NUMERIC(7, 2) |
NO |
|
| FullTimeMin |
|
NUMERIC(7, 2) |
YES |
|
| HalfTimeMin |
|
NUMERIC(7, 2) |
YES |
|
| LessThanHalfTimeMin |
|
NUMERIC(7, 2) |
YES |
|
| ThreeQuarterrTimeMin |
|
NUMERIC(7, 2) |
YES |
|
| PaymentMethodology |
|
CHAR(1) |
YES |
|
| SchoolDefinedField1 |
|
VARCHAR(50) |
YES |
|
| SchoolDefinedField2 |
|
VARCHAR(50) |
YES |
|
| SchoolDefinedField3 |
|
VARCHAR(50) |
YES |
|
| SchoolDefinedField4 |
|
VARCHAR(50) |
YES |
|
| IsActive |
|
BIT |
NO |
|
| LastModifiedUserId |
|
INTEGER |
NO |
|
| CreatedDateTime |
|
DATETIME |
NO |
|
| LastModifiedDateTime |
|
DATETIME |
NO |
|
| RowVersion |
|
TIMESTAMP/DATE |
NO |
|
| TermsInAcademicYear |
|
INTEGER |
YES |
|
| TotalBooksSuppliesCost |
|
MONEY(19, 4) |
YES |
|
| TotalOtherCost |
|
MONEY(19, 4) |
YES |
|
| TotalTuitionCost |
|
MONEY(19, 4) |
YES |
|
| ReturnOfTitleIvPeriod |
|
CHAR(1) |
YES |
|
| RevenueUnits |
|
NUMERIC(7, 0) |
YES |
|
| IsDegreeProgram |
|
BIT |
NO |
|
| RevenuePeriod |
|
CHAR(1) |
YES |
|
| ProgramVersionUnitType |
|
CHAR(1) |
NO |
|
| IsClockToCreditPriorJuly2011 |
|
BIT |
NO |
|
| ServicerProgramIdentifier |
|
VARCHAR(16) |
YES |
|
| IsExternStartDateRequired |
|
BIT |
NO |
|
| IsEnglishProficiencyRequired |
|
BIT |
NO |
|
| EnglishProficiencyNotRequiredReason |
|
VARCHAR(2000) |
YES |
|
| ClockToCreditRatePriorJuly2011 |
|
NUMERIC(6, 2) |
NO |
|
| MinOnlineRegistrationCredits |
|
NUMERIC(9, 2) |
YES |
|
| MaxOnlineRegistrationCredits |
|
NUMERIC(9, 2) |
YES |
|
| IsOutsideProgramRegistrationAllowed |
|
BIT |
NO |
|
GradeLevelPromotionCodeId |
|
INTEGER |
YES |
|
| HoursYear1 |
|
NUMERIC(9, 2) |
NO |
|
| HoursYear2 |
|
NUMERIC(9, 2) |
NO |
|
| HoursYear3 |
|
NUMERIC(9, 2) |
NO |
|
| HoursYear4 |
|
NUMERIC(9, 2) |
NO |
|
| Note |
|
VARCHAR(1000) |
YES |
|
| CreditsYear1 |
|
NUMERIC(9, 2) |
NO |
|
| CreditsYear2 |
|
NUMERIC(9, 2) |
NO |
|
| CreditsYear3 |
|
NUMERIC(9, 2) |
NO |
|
| CreditsYear4 |
|
NUMERIC(9, 2) |
NO |
|
| ProRateCostFlag |
|
INTEGER |
NO |
|
| ExpectedCreditsPerTerm |
|
NUMERIC(7, 2) |
YES |
|
BudgetId |
|
INTEGER |
YES |
|
| CourseRefundPolicyId |
|
INTEGER |
YES |
|
| IsUndeclared |
|
BIT |
NO |
|
| RequiresAreaOfStudy |
|
BIT |
NO |
|
CIPCode |
|
VARCHAR(7) |
YES |
|
| ExternshipCreditHours |
|
NUMERIC(7, 2) |
NO |
|
| ExternshipClockHours |
|
NUMERIC(9, 2) |
NO |
|
| ExpectedHoursPerWeekExternship |
|
NUMERIC(9, 2) |
NO |
|
| NumberPaymentPeriodsTitleIvAcademicYear |
|
INTEGER |
NO |
|
| NumberPaymentPeriodsNonTitleIvAcademicYear |
|
INTEGER |
NO |
|
| TranscriptDescription |
|
VARCHAR(120) |
YES |
|
| ReturnOfTitleIvPeriodReenroll |
|
CHAR(1) |
YES |
|
| ReturnOfTitleIvEnrollmentPeriodType |
|
CHAR(1) |
YES |
|
| DoNotUsePaymentPeriods |
|
BIT |
YES |
|
| IsRevenueIncludedIn9010Report |
|
BIT |
NO |
|
| AcademicYearType |
|
CHAR(1) |
YES |
|
| IsExcludedCrmIntegration |
|
BIT |
NO |
|
| IsRequiredToTakeAttendance |
|
BIT |
NO |
|
| IsTitleIvEligible |
|
BIT |
NO |
|
| SummerTermHeaderOrTrailer |
|
TINYINT |
NO |
|
| SummerTermPackaging |
|
BIT |
NO |
|
| SummerTermCredits |
|
NUMERIC(9, 4) |
NO |
|
| CreditBalanceScheduleDateType |
|
CHAR(2) |
YES |
|
| CreditBalanceScheduleDateTypeOffsetDays |
|
SMALLINT |
YES |
|
| IsSapBasedOnPaymentPeriod |
|
BIT |
NO |
|
| ClockToCreditRate |
|
NUMERIC(6, 2) |
NO |
|
| IsClockToCredit |
|
BIT |
NO |
|
| IsIncrementalBillEarn |
|
BIT |
NO |
|
| IsWaitListingRestricted |
|
BIT |
NO |
|
| firstMonthPercentage |
|
NUMERIC(5, 2) |
YES |
|
| IsScheduledHoursUsed |
|
BIT |
YES |
|
| AttendanceWithdrawalDateOption |
|
VARCHAR(8) |
YES |
|
| IsBudgetAutoRecalculated |
|
BIT |
NO |
|
| DefaultSpecialProgramType |
|
CHAR(1) |
NO |
|
| OutsideCourseWorkHours |
|
NUMERIC(9, 2) |
NO |
|
| FinancialAidCredits |
|
NUMERIC(9, 2) |
NO |
|
| IsNonSe9W |
|
BIT |
NO |
|
| ProgramLengthType |
|
CHAR(1) |
YES |
|
| ProgramLengthValue |
|
VARCHAR(7) |
YES |
|
GradeLevelPromotionRuleId |
|
INTEGER |
YES |
|
| Key Name |
Key Type |
Keys |
| AdProgramVersion_AdProgramGroupID_N_N_IDX |
Inversion Entry |
ProgramGroupId |
| AdProgramVersion_AdGradeLevelPromotionID_N_N_IDX |
Inversion Entry |
GradeLevelPromotionCodeId |
| AdProgramVersion_AdDegreeId_N_N_IDX |
Inversion Entry |
DegreeId |
| AdProgramVersion_CIPCode_N_N_IDX |
Inversion Entry |
CIPCode |
| AdProgramVersion_FaBudgetID_N_N_IDX |
Inversion Entry |
BudgetId |
| AdProgramVersion_AdProgramVersionID_U_C_IDX |
PrimaryKey |
ProgramVersionId |
| AdProgramVersion_SyCampusGrpID_N_N_IDX |
Inversion Entry |
CampusGroupId |
| AdProgramVersion_AdProgramVersionID_ClockCredit_U_N_IDX |
Alternate Key |
ProgramVersionId, ProgramVersionUnitType |